package org.jeecg.modules.lab.utensil.mapper;

import org.apache.coyote.OutputBuffer;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.lab.utensil.entity.LabUtensil;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.jeecg.modules.lab.utensil.entity.LabUtensilTo;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Description: 器具信息
 * @Author: jeecg-boot
 * @Date:   2023-07-11
 * @Version: V1.0
 */
@Repository
public interface LabUtensilMapper extends BaseMapper<LabUtensil> {


    /**
     * 通过设备id删除器具数据
     *
     * @param devId
     */
   public void deleteByDeviceId(@Param("devId") String devId);


   public void updateBy(LabUtensil l);

   public void updateByManu(@Param("list")List list,@Param("newStatus")String des);

   //按分类统计数量
   public List<LabUtensilTo> queryType();
   //按状态统计
   public List<LabUtensilTo> queryStatus();

   //统计所有
    public String countAll();
}
